1.Write a plsql blocks using bulk collect, to select rows from employees table and insert it into another table

2. Select first 3 employees details for each department

3. Select the number of 'a' in a string

4. What is subquery and correlated sub query

5.Difference between views and materialized views

6.Diff between procedures n functions

7.Where did u use refcursor in the project

8.How to delete duplicates using joins

9.Diff types of subqueries

10. Collections and types

11. Which collection u used in the project

12.Analytical function , triggers , index , performance tuning. ,

13 You have 10000 records in one table and u have to copy 5000 records to another table...

14. Group function

15. Exceptions,package,function,procedure difference,analytical functions ,using exception some problems